package de.alex.schulzeit.db.subject;

public final class SubjectTable implements SubjectColumns {

	public static final String TABLE_NAME = SubjectTable.class.getSimpleName();
	public static final String SQL_CREATE = "CREATE TABLE SubjectTable (" +
			ID + " INTEGER PRIMARY KEY AUTOINCREMENT," +
			SUBJECT_NAME + " TEXT NOT NULL);";
	
	public static final String SQL_DROP = "DROP TABLE IF EXISTS " + TABLE_NAME;
	
	public static final String SQL_DUMMY1 = "INSERT INTO " + TABLE_NAME + " (" +
	SUBJECT_NAME + ") VALUES ('Mathe');";
	
	public static final String SQL_DUMMY2 = "INSERT INTO " + TABLE_NAME + " (" +
	SUBJECT_NAME + ") VALUES ('Deutsch');";
	
	public static final String SQL_DUMMY3 = "INSERT INTO " + TABLE_NAME + " (" +
	SUBJECT_NAME + ") VALUES ('Englisch');";
	
	public static final String SQL_DUMMY4 = "INSERT INTO " + TABLE_NAME + " (" +
	SUBJECT_NAME + ") VALUES ('Programmieren');";
	
}
